﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlTypes;
using Spring.Data;
using Spring.Data.Generic;
using Spring.Data.Common;
using Spring.Data.Objects.Generic;


namespace Kpmg.Projects.Kdc.Ticket
{
   public static class TestSearchDAO 
    {
        private static AdoTemplate template = AppConfigurer.AdoTemplate;
        private static string strBase = "select Team_Code from Agent_Team";
        public static IList<string> Show()
        {
            IList<string> lst = new List<string>();
            template.QueryWithRowCallbackDelegate(CommandType.Text, strBase, delegate(IDataReader idr)
            {
                string s = idr.GetString(0);
                lst.Add(s);
            }); 
            return lst; 
        }
        
    }
 
}
